package com.wocai.jrt.orgadmin.employee.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class EmployeeCommissionHistoryBean {
    /**
     * order by 排序语句
     * 对应数据库表字段 employee_commission_history
     */
    private String orderBy;

    /**
     * 分页开始记录
     * 对应数据库表字段 employee_commission_history
     */
    private Integer start;

    /**
     * 分页大小
     * 对应数据库表字段 employee_commission_history
     */
    private int pageSize = 10;

    /**
     * 是否指定 distinct 去除重复
     * 对应数据库表字段 employee_commission_history
     */
    private boolean distinct;

    /**
     * 逻辑or语句
     * 对应数据库表字段 employee_commission_history
     */
    private List<Criteria> oredCriteria;

    /**
     */
    public EmployeeCommissionHistoryBean() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置 order by 排序语句
     */
    public void setOrderBy(String orderBy) {
        this.orderBy = orderBy;
    }

    /**
     * 获得 order by 排序语句
     */
    public String getOrderBy() {
        return orderBy;
    }

    /**
     * 设置 start，分页开始记录
     */
    public void setStart(Integer start) {
        this.start = start;
    }

    /**
     * 获得 start，分页开始记录
     */
    public Integer getStart() {
        return start;
    }

    /**
     * 设置 pageSize，分页大小
     */
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    /**
     * 获得 pageSize，分页大小
     */
    public int getPageSize() {
        return pageSize;
    }

    /**
     * 设置是否指定 distinct 去除重复
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否设置了distinct语句，true是，false否。
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获得逻辑or语句
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * 添加逻辑or语句
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * 添加逻辑and语句
     */
    public void and(Criteria criteria) {
        criteria.setAndRelation(true);
        oredCriteria.add(criteria);
    }

    /**
     * 新建逻辑或or语句
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 新建逻辑and语句
     */
    public Criteria and() {
        Criteria criteria = createCriteriaInternal();
        criteria.setAndRelation(true);
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建查询条件，如果逻辑或为空，同时将查询条件放入。
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 创建新查询条件。
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除逻辑或or语句，并且distinct为false，不去重。
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * 该类对应数据库表 employee_commission_history
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void orCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition, true));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void orCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value, true));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void orCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2, true));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdIsNull() {
            orCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria orIdIsNotNull() {
            orCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria orIdEqualTo(String value) {
            orCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotEqualTo(String value) {
            orCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdGreaterThan(String value) {
            orCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdGreaterThanOrEqualTo(String value) {
            orCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLessThan(String value) {
            orCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLessThanOrEqualTo(String value) {
            orCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLike(String value) {
            orCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotLike(String value) {
            orCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria orIdIn(List<String> values) {
            orCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotIn(List<String> values) {
            orCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria orIdBetween(String value1, String value2) {
            orCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotBetween(String value1, String value2) {
            orCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdIsNull() {
            orCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria orOrderIdIsNotNull() {
            orCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria orOrderIdEqualTo(String value) {
            orCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotEqualTo(String value) {
            orCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdGreaterThan(String value) {
            orCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdGreaterThanOrEqualTo(String value) {
            orCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLessThan(String value) {
            orCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLessThanOrEqualTo(String value) {
            orCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLike(String value) {
            orCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotLike(String value) {
            orCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdIn(List<String> values) {
            orCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotIn(List<String> values) {
            orCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdBetween(String value1, String value2) {
            orCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotBetween(String value1, String value2) {
            orCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(String value) {
            addCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(String value) {
            addCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(String value) {
            addCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(String value) {
            addCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(String value) {
            addCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(String value) {
            addCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdIsNull() {
            orCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria orProductIdIsNotNull() {
            orCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria orProductIdEqualTo(String value) {
            orCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotEqualTo(String value) {
            orCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdGreaterThan(String value) {
            orCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdGreaterThanOrEqualTo(String value) {
            orCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLessThan(String value) {
            orCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLessThanOrEqualTo(String value) {
            orCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLike(String value) {
            addCriterion("product_id like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotLike(String value) {
            addCriterion("product_id not like", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLike(String value) {
            orCriterion("product_id like", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotLike(String value) {
            orCriterion("product_id not like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<String> values) {
            addCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<String> values) {
            addCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(String value1, String value2) {
            addCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(String value1, String value2) {
            addCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdIn(List<String> values) {
            orCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotIn(List<String> values) {
            orCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdBetween(String value1, String value2) {
            orCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotBetween(String value1, String value2) {
            orCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIsNull() {
            addCriterion("commission_rate is null");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIsNotNull() {
            addCriterion("commission_rate is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionRateEqualTo(Double value) {
            addCriterion("commission_rate =", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotEqualTo(Double value) {
            addCriterion("commission_rate <>", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateGreaterThan(Double value) {
            addCriterion("commission_rate >", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateGreaterThanOrEqualTo(Double value) {
            addCriterion("commission_rate >=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateLessThan(Double value) {
            addCriterion("commission_rate <", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateLessThanOrEqualTo(Double value) {
            addCriterion("commission_rate <=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateIsNull() {
            orCriterion("commission_rate is null");
            return (Criteria) this;
        }

        public Criteria orCommissionRateIsNotNull() {
            orCriterion("commission_rate is not null");
            return (Criteria) this;
        }

        public Criteria orCommissionRateEqualTo(Double value) {
            orCriterion("commission_rate =", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateNotEqualTo(Double value) {
            orCriterion("commission_rate <>", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateGreaterThan(Double value) {
            orCriterion("commission_rate >", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateGreaterThanOrEqualTo(Double value) {
            orCriterion("commission_rate >=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateLessThan(Double value) {
            orCriterion("commission_rate <", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateLessThanOrEqualTo(Double value) {
            orCriterion("commission_rate <=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIn(List<Double> values) {
            addCriterion("commission_rate in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotIn(List<Double> values) {
            addCriterion("commission_rate not in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateBetween(Double value1, Double value2) {
            addCriterion("commission_rate between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotBetween(Double value1, Double value2) {
            addCriterion("commission_rate not between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateIn(List<Double> values) {
            orCriterion("commission_rate in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateNotIn(List<Double> values) {
            orCriterion("commission_rate not in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateBetween(Double value1, Double value2) {
            orCriterion("commission_rate between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria orCommissionRateNotBetween(Double value1, Double value2) {
            orCriterion("commission_rate not between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(Double value) {
            addCriterion("commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(Double value) {
            addCriterion("commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(Double value) {
            addCriterion("commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(Double value) {
            addCriterion("commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(Double value) {
            addCriterion("commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(Double value) {
            addCriterion("commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionIsNull() {
            orCriterion("commission is null");
            return (Criteria) this;
        }

        public Criteria orCommissionIsNotNull() {
            orCriterion("commission is not null");
            return (Criteria) this;
        }

        public Criteria orCommissionEqualTo(Double value) {
            orCriterion("commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionNotEqualTo(Double value) {
            orCriterion("commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionGreaterThan(Double value) {
            orCriterion("commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionGreaterThanOrEqualTo(Double value) {
            orCriterion("commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionLessThan(Double value) {
            orCriterion("commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionLessThanOrEqualTo(Double value) {
            orCriterion("commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<Double> values) {
            addCriterion("commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<Double> values) {
            addCriterion("commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(Double value1, Double value2) {
            addCriterion("commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(Double value1, Double value2) {
            addCriterion("commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionIn(List<Double> values) {
            orCriterion("commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionNotIn(List<Double> values) {
            orCriterion("commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionBetween(Double value1, Double value2) {
            orCriterion("commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria orCommissionNotBetween(Double value1, Double value2) {
            orCriterion("commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNull() {
            addCriterion("employee_id is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNotNull() {
            addCriterion("employee_id is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdEqualTo(String value) {
            addCriterion("employee_id =", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotEqualTo(String value) {
            addCriterion("employee_id <>", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThan(String value) {
            addCriterion("employee_id >", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThanOrEqualTo(String value) {
            addCriterion("employee_id >=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThan(String value) {
            addCriterion("employee_id <", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThanOrEqualTo(String value) {
            addCriterion("employee_id <=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIsNull() {
            orCriterion("employee_id is null");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIsNotNull() {
            orCriterion("employee_id is not null");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdEqualTo(String value) {
            orCriterion("employee_id =", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotEqualTo(String value) {
            orCriterion("employee_id <>", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdGreaterThan(String value) {
            orCriterion("employee_id >", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdGreaterThanOrEqualTo(String value) {
            orCriterion("employee_id >=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLessThan(String value) {
            orCriterion("employee_id <", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLessThanOrEqualTo(String value) {
            orCriterion("employee_id <=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLike(String value) {
            addCriterion("employee_id like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotLike(String value) {
            addCriterion("employee_id not like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLike(String value) {
            orCriterion("employee_id like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotLike(String value) {
            orCriterion("employee_id not like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIn(List<String> values) {
            addCriterion("employee_id in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotIn(List<String> values) {
            addCriterion("employee_id not in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdBetween(String value1, String value2) {
            addCriterion("employee_id between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotBetween(String value1, String value2) {
            addCriterion("employee_id not between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIn(List<String> values) {
            orCriterion("employee_id in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotIn(List<String> values) {
            orCriterion("employee_id not in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdBetween(String value1, String value2) {
            orCriterion("employee_id between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotBetween(String value1, String value2) {
            orCriterion("employee_id not between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeIsNull() {
            orCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria orCreateTimeIsNotNull() {
            orCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria orCreateTimeEqualTo(Date value) {
            orCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeNotEqualTo(Date value) {
            orCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeGreaterThan(Date value) {
            orCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeGreaterThanOrEqualTo(Date value) {
            orCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeLessThan(Date value) {
            orCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeLessThanOrEqualTo(Date value) {
            orCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeIn(List<Date> values) {
            orCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeNotIn(List<Date> values) {
            orCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeBetween(Date value1, Date value2) {
            orCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria orCreateTimeNotBetween(Date value1, Date value2) {
            orCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andDividendRateIsNull() {
            addCriterion("dividend_rate is null");
            return (Criteria) this;
        }

        public Criteria andDividendRateIsNotNull() {
            addCriterion("dividend_rate is not null");
            return (Criteria) this;
        }

        public Criteria andDividendRateEqualTo(Double value) {
            addCriterion("dividend_rate =", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateNotEqualTo(Double value) {
            addCriterion("dividend_rate <>", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateGreaterThan(Double value) {
            addCriterion("dividend_rate >", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateGreaterThanOrEqualTo(Double value) {
            addCriterion("dividend_rate >=", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateLessThan(Double value) {
            addCriterion("dividend_rate <", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateLessThanOrEqualTo(Double value) {
            addCriterion("dividend_rate <=", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateIsNull() {
            orCriterion("dividend_rate is null");
            return (Criteria) this;
        }

        public Criteria orDividendRateIsNotNull() {
            orCriterion("dividend_rate is not null");
            return (Criteria) this;
        }

        public Criteria orDividendRateEqualTo(Double value) {
            orCriterion("dividend_rate =", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateNotEqualTo(Double value) {
            orCriterion("dividend_rate <>", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateGreaterThan(Double value) {
            orCriterion("dividend_rate >", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateGreaterThanOrEqualTo(Double value) {
            orCriterion("dividend_rate >=", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateLessThan(Double value) {
            orCriterion("dividend_rate <", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateLessThanOrEqualTo(Double value) {
            orCriterion("dividend_rate <=", value, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateIn(List<Double> values) {
            addCriterion("dividend_rate in", values, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateNotIn(List<Double> values) {
            addCriterion("dividend_rate not in", values, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateBetween(Double value1, Double value2) {
            addCriterion("dividend_rate between", value1, value2, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendRateNotBetween(Double value1, Double value2) {
            addCriterion("dividend_rate not between", value1, value2, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateIn(List<Double> values) {
            orCriterion("dividend_rate in", values, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateNotIn(List<Double> values) {
            orCriterion("dividend_rate not in", values, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateBetween(Double value1, Double value2) {
            orCriterion("dividend_rate between", value1, value2, "dividendRate");
            return (Criteria) this;
        }

        public Criteria orDividendRateNotBetween(Double value1, Double value2) {
            orCriterion("dividend_rate not between", value1, value2, "dividendRate");
            return (Criteria) this;
        }

        public Criteria andDividendIsNull() {
            addCriterion("dividend is null");
            return (Criteria) this;
        }

        public Criteria andDividendIsNotNull() {
            addCriterion("dividend is not null");
            return (Criteria) this;
        }

        public Criteria andDividendEqualTo(Double value) {
            addCriterion("dividend =", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendNotEqualTo(Double value) {
            addCriterion("dividend <>", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendGreaterThan(Double value) {
            addCriterion("dividend >", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendGreaterThanOrEqualTo(Double value) {
            addCriterion("dividend >=", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendLessThan(Double value) {
            addCriterion("dividend <", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendLessThanOrEqualTo(Double value) {
            addCriterion("dividend <=", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendIsNull() {
            orCriterion("dividend is null");
            return (Criteria) this;
        }

        public Criteria orDividendIsNotNull() {
            orCriterion("dividend is not null");
            return (Criteria) this;
        }

        public Criteria orDividendEqualTo(Double value) {
            orCriterion("dividend =", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendNotEqualTo(Double value) {
            orCriterion("dividend <>", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendGreaterThan(Double value) {
            orCriterion("dividend >", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendGreaterThanOrEqualTo(Double value) {
            orCriterion("dividend >=", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendLessThan(Double value) {
            orCriterion("dividend <", value, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendLessThanOrEqualTo(Double value) {
            orCriterion("dividend <=", value, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendIn(List<Double> values) {
            addCriterion("dividend in", values, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendNotIn(List<Double> values) {
            addCriterion("dividend not in", values, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendBetween(Double value1, Double value2) {
            addCriterion("dividend between", value1, value2, "dividend");
            return (Criteria) this;
        }

        public Criteria andDividendNotBetween(Double value1, Double value2) {
            addCriterion("dividend not between", value1, value2, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendIn(List<Double> values) {
            orCriterion("dividend in", values, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendNotIn(List<Double> values) {
            orCriterion("dividend not in", values, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendBetween(Double value1, Double value2) {
            orCriterion("dividend between", value1, value2, "dividend");
            return (Criteria) this;
        }

        public Criteria orDividendNotBetween(Double value1, Double value2) {
            orCriterion("dividend not between", value1, value2, "dividend");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateIsNull() {
            orCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria orStateIsNotNull() {
            orCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria orStateEqualTo(Integer value) {
            orCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotEqualTo(Integer value) {
            orCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateGreaterThan(Integer value) {
            orCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateGreaterThanOrEqualTo(Integer value) {
            orCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateLessThan(Integer value) {
            orCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateLessThanOrEqualTo(Integer value) {
            orCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria orStateIn(List<Integer> values) {
            orCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotIn(List<Integer> values) {
            orCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria orStateBetween(Integer value1, Integer value2) {
            orCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotBetween(Integer value1, Integer value2) {
            orCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIsNull() {
            addCriterion("audit_time is null");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIsNotNull() {
            addCriterion("audit_time is not null");
            return (Criteria) this;
        }

        public Criteria andAuditTimeEqualTo(Date value) {
            addCriterion("audit_time =", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotEqualTo(Date value) {
            addCriterion("audit_time <>", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeGreaterThan(Date value) {
            addCriterion("audit_time >", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("audit_time >=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeLessThan(Date value) {
            addCriterion("audit_time <", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeLessThanOrEqualTo(Date value) {
            addCriterion("audit_time <=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeIsNull() {
            orCriterion("audit_time is null");
            return (Criteria) this;
        }

        public Criteria orAuditTimeIsNotNull() {
            orCriterion("audit_time is not null");
            return (Criteria) this;
        }

        public Criteria orAuditTimeEqualTo(Date value) {
            orCriterion("audit_time =", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeNotEqualTo(Date value) {
            orCriterion("audit_time <>", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeGreaterThan(Date value) {
            orCriterion("audit_time >", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeGreaterThanOrEqualTo(Date value) {
            orCriterion("audit_time >=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeLessThan(Date value) {
            orCriterion("audit_time <", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeLessThanOrEqualTo(Date value) {
            orCriterion("audit_time <=", value, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeIn(List<Date> values) {
            addCriterion("audit_time in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotIn(List<Date> values) {
            addCriterion("audit_time not in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeBetween(Date value1, Date value2) {
            addCriterion("audit_time between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditTimeNotBetween(Date value1, Date value2) {
            addCriterion("audit_time not between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeIn(List<Date> values) {
            orCriterion("audit_time in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeNotIn(List<Date> values) {
            orCriterion("audit_time not in", values, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeBetween(Date value1, Date value2) {
            orCriterion("audit_time between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria orAuditTimeNotBetween(Date value1, Date value2) {
            orCriterion("audit_time not between", value1, value2, "auditTime");
            return (Criteria) this;
        }

        public Criteria andAuditIdIsNull() {
            addCriterion("audit_id is null");
            return (Criteria) this;
        }

        public Criteria andAuditIdIsNotNull() {
            addCriterion("audit_id is not null");
            return (Criteria) this;
        }

        public Criteria andAuditIdEqualTo(String value) {
            addCriterion("audit_id =", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdNotEqualTo(String value) {
            addCriterion("audit_id <>", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdGreaterThan(String value) {
            addCriterion("audit_id >", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdGreaterThanOrEqualTo(String value) {
            addCriterion("audit_id >=", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdLessThan(String value) {
            addCriterion("audit_id <", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdLessThanOrEqualTo(String value) {
            addCriterion("audit_id <=", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdIsNull() {
            orCriterion("audit_id is null");
            return (Criteria) this;
        }

        public Criteria orAuditIdIsNotNull() {
            orCriterion("audit_id is not null");
            return (Criteria) this;
        }

        public Criteria orAuditIdEqualTo(String value) {
            orCriterion("audit_id =", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdNotEqualTo(String value) {
            orCriterion("audit_id <>", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdGreaterThan(String value) {
            orCriterion("audit_id >", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdGreaterThanOrEqualTo(String value) {
            orCriterion("audit_id >=", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdLessThan(String value) {
            orCriterion("audit_id <", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdLessThanOrEqualTo(String value) {
            orCriterion("audit_id <=", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdLike(String value) {
            addCriterion("audit_id like", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdNotLike(String value) {
            addCriterion("audit_id not like", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdLike(String value) {
            orCriterion("audit_id like", value, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdNotLike(String value) {
            orCriterion("audit_id not like", value, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdIn(List<String> values) {
            addCriterion("audit_id in", values, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdNotIn(List<String> values) {
            addCriterion("audit_id not in", values, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdBetween(String value1, String value2) {
            addCriterion("audit_id between", value1, value2, "auditId");
            return (Criteria) this;
        }

        public Criteria andAuditIdNotBetween(String value1, String value2) {
            addCriterion("audit_id not between", value1, value2, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdIn(List<String> values) {
            orCriterion("audit_id in", values, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdNotIn(List<String> values) {
            orCriterion("audit_id not in", values, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdBetween(String value1, String value2) {
            orCriterion("audit_id between", value1, value2, "auditId");
            return (Criteria) this;
        }

        public Criteria orAuditIdNotBetween(String value1, String value2) {
            orCriterion("audit_id not between", value1, value2, "auditId");
            return (Criteria) this;
        }

        public Criteria andCPayTimeIsNull() {
            addCriterion("c_pay_time is null");
            return (Criteria) this;
        }

        public Criteria andCPayTimeIsNotNull() {
            addCriterion("c_pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andCPayTimeEqualTo(Date value) {
            addCriterion("c_pay_time =", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeNotEqualTo(Date value) {
            addCriterion("c_pay_time <>", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeGreaterThan(Date value) {
            addCriterion("c_pay_time >", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("c_pay_time >=", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeLessThan(Date value) {
            addCriterion("c_pay_time <", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("c_pay_time <=", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeIsNull() {
            orCriterion("c_pay_time is null");
            return (Criteria) this;
        }

        public Criteria orCPayTimeIsNotNull() {
            orCriterion("c_pay_time is not null");
            return (Criteria) this;
        }

        public Criteria orCPayTimeEqualTo(Date value) {
            orCriterion("c_pay_time =", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeNotEqualTo(Date value) {
            orCriterion("c_pay_time <>", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeGreaterThan(Date value) {
            orCriterion("c_pay_time >", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeGreaterThanOrEqualTo(Date value) {
            orCriterion("c_pay_time >=", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeLessThan(Date value) {
            orCriterion("c_pay_time <", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeLessThanOrEqualTo(Date value) {
            orCriterion("c_pay_time <=", value, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeIn(List<Date> values) {
            addCriterion("c_pay_time in", values, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeNotIn(List<Date> values) {
            addCriterion("c_pay_time not in", values, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeBetween(Date value1, Date value2) {
            addCriterion("c_pay_time between", value1, value2, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("c_pay_time not between", value1, value2, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeIn(List<Date> values) {
            orCriterion("c_pay_time in", values, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeNotIn(List<Date> values) {
            orCriterion("c_pay_time not in", values, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeBetween(Date value1, Date value2) {
            orCriterion("c_pay_time between", value1, value2, "cPayTime");
            return (Criteria) this;
        }

        public Criteria orCPayTimeNotBetween(Date value1, Date value2) {
            orCriterion("c_pay_time not between", value1, value2, "cPayTime");
            return (Criteria) this;
        }

        public Criteria andCPayIdIsNull() {
            addCriterion("c_pay_id is null");
            return (Criteria) this;
        }

        public Criteria andCPayIdIsNotNull() {
            addCriterion("c_pay_id is not null");
            return (Criteria) this;
        }

        public Criteria andCPayIdEqualTo(String value) {
            addCriterion("c_pay_id =", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdNotEqualTo(String value) {
            addCriterion("c_pay_id <>", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdGreaterThan(String value) {
            addCriterion("c_pay_id >", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdGreaterThanOrEqualTo(String value) {
            addCriterion("c_pay_id >=", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdLessThan(String value) {
            addCriterion("c_pay_id <", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdLessThanOrEqualTo(String value) {
            addCriterion("c_pay_id <=", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdIsNull() {
            orCriterion("c_pay_id is null");
            return (Criteria) this;
        }

        public Criteria orCPayIdIsNotNull() {
            orCriterion("c_pay_id is not null");
            return (Criteria) this;
        }

        public Criteria orCPayIdEqualTo(String value) {
            orCriterion("c_pay_id =", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdNotEqualTo(String value) {
            orCriterion("c_pay_id <>", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdGreaterThan(String value) {
            orCriterion("c_pay_id >", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdGreaterThanOrEqualTo(String value) {
            orCriterion("c_pay_id >=", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdLessThan(String value) {
            orCriterion("c_pay_id <", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdLessThanOrEqualTo(String value) {
            orCriterion("c_pay_id <=", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdLike(String value) {
            addCriterion("c_pay_id like", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdNotLike(String value) {
            addCriterion("c_pay_id not like", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdLike(String value) {
            orCriterion("c_pay_id like", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdNotLike(String value) {
            orCriterion("c_pay_id not like", value, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdIn(List<String> values) {
            addCriterion("c_pay_id in", values, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdNotIn(List<String> values) {
            addCriterion("c_pay_id not in", values, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdBetween(String value1, String value2) {
            addCriterion("c_pay_id between", value1, value2, "cPayId");
            return (Criteria) this;
        }

        public Criteria andCPayIdNotBetween(String value1, String value2) {
            addCriterion("c_pay_id not between", value1, value2, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdIn(List<String> values) {
            orCriterion("c_pay_id in", values, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdNotIn(List<String> values) {
            orCriterion("c_pay_id not in", values, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdBetween(String value1, String value2) {
            orCriterion("c_pay_id between", value1, value2, "cPayId");
            return (Criteria) this;
        }

        public Criteria orCPayIdNotBetween(String value1, String value2) {
            orCriterion("c_pay_id not between", value1, value2, "cPayId");
            return (Criteria) this;
        }
    }

    /**
     * 该类对应数据库表 employee_commission_history
     */
    public static class Criteria extends GeneratedCriteria {
        protected boolean andRelation;

        public boolean isAndRelation() {
            return andRelation;
        }

        protected Criteria() {
            super();
        }

        public void setAndRelation(boolean andRelation) {
            this.andRelation = andRelation;
        }
    }

    /**
     * 该类对应数据库表 employee_commission_history
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean orValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isOrValue() {
            return orValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, boolean orValue) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
            this.orValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, boolean orValue) {
            this(condition, value, null);
            this.orValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, boolean orValue) {
            this(condition, value, secondValue, null);
            this.orValue = true;
        }
    }
}